﻿CREATE PROCEDURE [dbo].[AddAuctioneer]	
	@username nvarchar(50),
	@firstname nvarchar(50),
	@lastname nvarchar(50),
	@password nvarchar(50),
	@rating decimal(18,1),
	@id int output
AS
	INSERT INTO Auctioneer(Username, FirstName, LastName, Password, Rating) VALUES(@username, @firstname, @lastname, @password, @rating)
	SET @id = SCOPE_IDENTITY();